Searching For Specific Records

Access also allows you to search for specific records in which fields have a specific value. We will search for all records that have a value of "Grocery" in the Dept field.

Click the View button on the toolbar


    Access displays your query in design view.

Click the left button on the horizontal scroll bar until the Dept field appears

Click in the Criteria Row under Dept

Type ="Grocery"

Click the Run button on the toolbar

    Your query should look like the one below:


    Access displays only the records whose Dept field has a value of "Grocery"

Now you try!